How to connect Quicken & QuickBooks to digital banking

Instructions for One-Step Update initiated from within Quicken.

Optional steps to take:

1. Back up your Quicken Windows Data File. Go to File > Backup and Restore > Backup Quicken File.
2. Download the latest Quicken Update. Go to Help > Check for Updates.

Steps to take to connect to digital banking:

1. Deactivate old connections if applicable:

1. Choose Tools > Account List.
2. Click Edit on the account to deactivate.
3. In Account Details, click Online Services.
4. Click Deactivate. Follow prompts to confirm deactivation.
5. Click the General tab.
6. Delete Financial Institution and Account Number information. Click OK to close window.
7. Repeat steps for any additional accounts that apply.

2. Connect to digital banking for your RCU accounts:

1. Choose Tools > Account List.
2. Click Edit on the account you want to activate.
3. In Account Details, click Online Services and then choose Set up Now.
4. Type "Redwood Credit Union" in the search field and click Next.
5. Select Redwood Credit Union Digital
6. Enter your RCU credentials. Express Web Connect uses the same credentials you use for your RCU digital banking login.
   Important: If your credentials do not work, contact RCU.
7. Be sure to associate the accounts to the appropriate accounts already listed in Quicken. Select Link to an existing account and select the matching accounts in the drop-down menu.
   Important: Do NOT choose “Create a new account” unless you intend to add a new account to Quicken. If you are presented with accounts you do not want to track in this data file, choose Ignore – Don’t Download into Quicken or click Cancel.
8. After all accounts have been matched, click Next and then Done.

Optional steps to take:

1. Back up Quicken Windows data file and update:

1. Choose File > Backup and Restore > Backup Quicken File.
2. Download the latest Quicken Update. Choose Help > Check for Updates.

Steps to take to connect to digital banking:

1. Connect to digital banking for your RCU accounts:

1. Select your account under the Accounts list on the left side
2. Choose Accounts > Settings.
3. Select Set up transaction download.
4. Enter "Redwood Credit Union" in the search field, select Redwood Credit Union Digital and click Continue.
5. Log into RCU’s digital banking site and download your transactions to your computer.
   Important: Take note of the date you last had a successful connection. If you have overlapping dates in the Web-Connect process, you may end up with duplicate transactions.
6. Drag and drop the downloaded file into the box titled Drop download file. If prompted, choose Web Connect for the “Connection Type.”.
7. In the “Accounts Found” screen, be sure to associate each new account to the appropriate account already listed in Quicken. Under the Action column, click Link to choose your existing account.
   Important: Do NOT select “ADD” in the Action column unless you intend to add a new account to Quicken.
8. Click Finish.

Optional steps to take:

1. Backup your Quicken Mac data file and update the application:

1. Choose File > Save a Backup.
2. Download the latest Quicken Update. Choose Quicken > Check for Updates

Steps to take to connect to digital banking:

1. Connect to digital banking for your RCU accounts:

1. Select your account under the Accounts list on the left side
2. Choose Accounts > Settings.
3. Select Set up transaction download.
4. Enter "Redwood Credit Union" in the search field, select Redwood Credit Union Digital and click Continue.
5. Log into RCU’s digital banking site and download your transactions to your computer.
   Important: Take note of the date you last had a successful connection. If you have overlapping dates in the Web-Connect process, you may end up with duplicate transactions.
6. Drag and drop the downloaded file into the box titled Drop download file. If prompted, choose Web Connect for the “Connection Type.”.
7. In the “Accounts Found” screen, be sure to associate each new account to the appropriate account already listed in Quicken. Under the Action column, click Link to choose your existing account.
   Important: Do NOT select “ADD” in the Action column unless you intend to add a new account to Quicken.
8. Click Finish.

Optional steps to take:

1. Backup in Quicken for Mac:

1. Choose File > Save a Backup.
2. Choose a place on your Mac to save the file
3. Click Save. The Quicken backup file will have the extension .quicken2017backup or .quickenbackup

Steps to take to connect to digital banking:

1. Deactivate old connections if applicable:

1. Select the account to open its register.
2. Click the Settings gear icon in the lower right corner of the register.
3. Click the Downloads tab.
4. Click the Disconnect account button.
5. Click Done.

Important: If you are deactivating/reactivating an account to fix an issue, you'll need to deactivate all the accounts with the affected financial institution that you have activated in Quicken (including hidden ones). Once they're all deactivated, then you can follow the steps to reactivate.

2. Connect to digital banking for RCU accounts:

1. Select the account to open its register.
2. Click the Settings gear in the lower right corner of the register.
3. Click the Downloads tab.
4. Click the Connect Account button.
5. Select the financial institution or type in the name to search for it.
6. Click Continue and complete the flow.
7. Choose LINK on the screen displayed after Quicken finds the available accounts at the financial institution for your login credentials, and carefully link to your existing Quicken account(s).
8. Click Continue.

Issues You May Encounter

• Duplicate Transactions
  • Reactivating for the new connection method may result in a re-download of the most recent 90 days of transactions (depending on the financial institution).
  • These duplicate transactions should Match to those that already exist in the register, but you should review the data after the reactivation to ensure you're not seeing duplicates.
  • Once a duplicate transaction already exists in your account register, the only solution is to delete it.
• Online Bill Pay Service Unavailable
  • If you were using your bank's online bill payment service and have been told to deactivate your Direct Connect accounts, the reactivation for Quicken Connect will not offer the bank's bill pay service.
  • If you were advised by your bank to make this change because they will no longer offer this service through Quicken, one option is to sign up for Quicken Bill Manager.
  • If you choose to continue using your bank's bill pay service, you can still make payments at the bank's website and the posted payments would continue to download to Quicken via Quicken Connect update.

Instructions for Downloading a Web Connect file from your digital banking site.

Optional steps to take:

1. Backup QuickBooks Windows data file and update:

1. Choose File > Back Up Company > Create Local Backup.
2. Download the latest QuickBooks Update. Choose Help > Update QuickBooks Desktop.

Steps to take to connect to digital banking:

1. Deactivate old connections if applicable:

1. Choose Lists menu > Chart of Accounts.
2. Right-click the first account you want to deactivate and choose Edit Account.
3. Click the Bank Feeds Settings tab in the Edit Account window.
4. Select Deactivate All Online Services and click Save & Close.
5. Click OK for any alerts or messages that may appear with the deactivation.
6. Repeat steps for any additional accounts that you need to deactivate.

2. Connect to digital banking for RCU accounts:

1. Log in to your RCU digital banking site and download your transactions to a QuickBooks (.qbo) file.
   Note: Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
2. In QuickBooks, choose File > Utilities > Import > Web Connect Files. Locate your saved Web Connect file and select to import.
3. Under Select Bank Account, select Use an existing QuickBooks account.
   Important: Do NOT select "Create a new QuickBooks account" unless you intend to add a new account to QuickBooks.
4. In the drop-down list, choose your QuickBooks account(s) and click Continue. Confirm by selecting OK.

Instructions for Downloading a Web Connect file from your digital banking site:

Optional steps to take:

1. Backup your QuickBooks Mac data file and update the application:

1. Choose File > Backup.
2. Download the latest QuickBooks Update. Choose QuickBooks > Check for QuickBooks Updates.

Steps to take to connect to digital banking:

1. Deactivate old connections if applicable:

1. Choose Lists > Chart of Accounts.
2. Select the first account you would like to deactivate and choose Edit > Edit Account.
3. Select Online Settings in the Edit Account window.
4. In the Online Account Information window, choose Not Enabled from the Download Transactions list and click Save.
5. Click OK for any prompts that may appear with the deactivation.
6. Repeat steps for any additional accounts that apply.

2. Connect to digital banking for RCU accounts:

1. Log in to RCU’s digital banking site and download your transactions into to a QuickBooks (.qbo) file.
   Important: Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
2. In QuickBooks, choose File > Import > From Web Connect. Select your saved Web Connect file.
3. In the Account Association window, click Select an Account to choose the appropriate existing account register.
   Important: Do NOT select “NEW” under the action column unless you intend to add a new account to QuickBooks.
4. Click Continue and OK for any prompts that require action.

Instructions for One-Step Update initiated from within QuickBooks Online:

Optional steps to take:

1. Complete a final transaction download.
2. Complete last transaction update before the change to get all of your transaction history up to date.
3. Accept all new transactions into the appropriate registers.

Steps to take to connect to digital banking:

1. Deactivate old connections if applicable:

1. Select Banking from the left column.
2. Click the account you want to disconnect, then click the Pencil Icon on the corner of that account box.
3. Click Edit Account Info.
4. Check the box next to Disconnect this Account on Save.
5. Select Save and Close.
6. Repeat steps for any additional accounts that apply.

2. Connect to digital banking for RCU accounts:

1. On the Banking page, click Add Account at upper right.
2. Type in "Redwood Credit Union" and select Redwood Credit Union Digital from the results.
3. Enter your RCU digital banking credentials and click Continue. Express Web Connect uses the same credentials you use for your digital banking.
4. Provide additional information, if requested.
5. Ensure you associate the accounts for RCU to the appropriate account already listed under Which accounts do you want to connect? Choose the matching accounts in the drop-down menu.
   Important: Do NOT select “+Add New” unless you intend to add a new account to QuickBooks Online. If you are presented with accounts you do not want to track in this QuickBooks Online Company, uncheck the box next to the Account Name.
6. After all accounts have been matched, click Connect and then click Finish.

3. Exclude duplicate transactions:

1. Select Banking from the left column.
2. In the For Review section, click the checkboxes for the transactions you want to exclude.
3. Choose Batch Actions > Exclude Selected.

Instructions for downloading a Web Connect file from your digital banking site:

Optional steps to take:

1. Complete a final transaction download.
2. Complete last transaction update before the change to get all of your transaction history up to date.
3. Accept all new transactions into the appropriate registers.

Steps to take to connect to digital banking:

1. Deactivate old connections if applicable:

1. Select Banking from the left column.
2. Click on the account you would like to disconnect, then click the pencil icon on the corner of that account box.
3. Click Edit Account Info.
4. Check the box next to Disconnect this Account on Save.
5. Click Save and Close.
6. Repeat steps for any additional accounts that apply.

2. Connect to digital banking for RCU accounts.

1. Download a Web Connect file (.qbo or .qfx) from your financial institution’s digital banking site.
2. In QuickBooks Online, choose Banking from the left column.
3. Click File Upload at upper right, locate the Web Connect file you downloaded in step 1.
4. Choose the appropriate account from the drop-down menu under QuickBooks Account and then click Next.
   Important: Do NOT choose “+Add New” in the drop-down menu unless you intend to add a new account to QuickBooks Online.
5. When the import is finished, click Let’s go!
6. Review the For Review tab on the Banking page to view what was downloaded.
7. Click Next, and then click Done.
8. Repeat this step for each account that you have connected to RCU.